package com.ai.emall.bean.gbean;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class ProductSkuExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ProductSkuExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andSkuIdIsNull() {
            addCriterion("sku_id is null");
            return (Criteria) this;
        }

        public Criteria andSkuIdIsNotNull() {
            addCriterion("sku_id is not null");
            return (Criteria) this;
        }

        public Criteria andSkuIdEqualTo(Long value) {
            addCriterion("sku_id =", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotEqualTo(Long value) {
            addCriterion("sku_id <>", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThan(Long value) {
            addCriterion("sku_id >", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThanOrEqualTo(Long value) {
            addCriterion("sku_id >=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThan(Long value) {
            addCriterion("sku_id <", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThanOrEqualTo(Long value) {
            addCriterion("sku_id <=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdIn(List<Long> values) {
            addCriterion("sku_id in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotIn(List<Long> values) {
            addCriterion("sku_id not in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdBetween(Long value1, Long value2) {
            addCriterion("sku_id between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotBetween(Long value1, Long value2) {
            addCriterion("sku_id not between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("PRODUCT_ID is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("PRODUCT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Long value) {
            addCriterion("PRODUCT_ID =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Long value) {
            addCriterion("PRODUCT_ID <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Long value) {
            addCriterion("PRODUCT_ID >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Long value) {
            addCriterion("PRODUCT_ID >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Long value) {
            addCriterion("PRODUCT_ID <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Long value) {
            addCriterion("PRODUCT_ID <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Long> values) {
            addCriterion("PRODUCT_ID in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Long> values) {
            addCriterion("PRODUCT_ID not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Long value1, Long value2) {
            addCriterion("PRODUCT_ID between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Long value1, Long value2) {
            addCriterion("PRODUCT_ID not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andPriceModeIsNull() {
            addCriterion("PRICE_MODE is null");
            return (Criteria) this;
        }

        public Criteria andPriceModeIsNotNull() {
            addCriterion("PRICE_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceModeEqualTo(Integer value) {
            addCriterion("PRICE_MODE =", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeNotEqualTo(Integer value) {
            addCriterion("PRICE_MODE <>", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeGreaterThan(Integer value) {
            addCriterion("PRICE_MODE >", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("PRICE_MODE >=", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeLessThan(Integer value) {
            addCriterion("PRICE_MODE <", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeLessThanOrEqualTo(Integer value) {
            addCriterion("PRICE_MODE <=", value, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeIn(List<Integer> values) {
            addCriterion("PRICE_MODE in", values, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeNotIn(List<Integer> values) {
            addCriterion("PRICE_MODE not in", values, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeBetween(Integer value1, Integer value2) {
            addCriterion("PRICE_MODE between", value1, value2, "priceMode");
            return (Criteria) this;
        }

        public Criteria andPriceModeNotBetween(Integer value1, Integer value2) {
            addCriterion("PRICE_MODE not between", value1, value2, "priceMode");
            return (Criteria) this;
        }

        public Criteria andNormalPriceIsNull() {
            addCriterion("NORMAL_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andNormalPriceIsNotNull() {
            addCriterion("NORMAL_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andNormalPriceEqualTo(Double value) {
            addCriterion("NORMAL_PRICE =", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceNotEqualTo(Double value) {
            addCriterion("NORMAL_PRICE <>", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceGreaterThan(Double value) {
            addCriterion("NORMAL_PRICE >", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("NORMAL_PRICE >=", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceLessThan(Double value) {
            addCriterion("NORMAL_PRICE <", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceLessThanOrEqualTo(Double value) {
            addCriterion("NORMAL_PRICE <=", value, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceIn(List<Double> values) {
            addCriterion("NORMAL_PRICE in", values, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceNotIn(List<Double> values) {
            addCriterion("NORMAL_PRICE not in", values, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceBetween(Double value1, Double value2) {
            addCriterion("NORMAL_PRICE between", value1, value2, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andNormalPriceNotBetween(Double value1, Double value2) {
            addCriterion("NORMAL_PRICE not between", value1, value2, "normalPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("DISCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("DISCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(Double value) {
            addCriterion("DISCOUNT =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(Double value) {
            addCriterion("DISCOUNT <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(Double value) {
            addCriterion("DISCOUNT >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(Double value) {
            addCriterion("DISCOUNT <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<Double> values) {
            addCriterion("DISCOUNT in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<Double> values) {
            addCriterion("DISCOUNT not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andSailPriceIsNull() {
            addCriterion("SAIL_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andSailPriceIsNotNull() {
            addCriterion("SAIL_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andSailPriceEqualTo(Double value) {
            addCriterion("SAIL_PRICE =", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceNotEqualTo(Double value) {
            addCriterion("SAIL_PRICE <>", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceGreaterThan(Double value) {
            addCriterion("SAIL_PRICE >", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("SAIL_PRICE >=", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceLessThan(Double value) {
            addCriterion("SAIL_PRICE <", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceLessThanOrEqualTo(Double value) {
            addCriterion("SAIL_PRICE <=", value, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceIn(List<Double> values) {
            addCriterion("SAIL_PRICE in", values, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceNotIn(List<Double> values) {
            addCriterion("SAIL_PRICE not in", values, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceBetween(Double value1, Double value2) {
            addCriterion("SAIL_PRICE between", value1, value2, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceNotBetween(Double value1, Double value2) {
            addCriterion("SAIL_PRICE not between", value1, value2, "sailPrice");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsIsNull() {
            addCriterion("SAIL_PRICE_TS is null");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsIsNotNull() {
            addCriterion("SAIL_PRICE_TS is not null");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsEqualTo(Long value) {
            addCriterion("SAIL_PRICE_TS =", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsNotEqualTo(Long value) {
            addCriterion("SAIL_PRICE_TS <>", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsGreaterThan(Long value) {
            addCriterion("SAIL_PRICE_TS >", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsGreaterThanOrEqualTo(Long value) {
            addCriterion("SAIL_PRICE_TS >=", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsLessThan(Long value) {
            addCriterion("SAIL_PRICE_TS <", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsLessThanOrEqualTo(Long value) {
            addCriterion("SAIL_PRICE_TS <=", value, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsIn(List<Long> values) {
            addCriterion("SAIL_PRICE_TS in", values, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsNotIn(List<Long> values) {
            addCriterion("SAIL_PRICE_TS not in", values, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsBetween(Long value1, Long value2) {
            addCriterion("SAIL_PRICE_TS between", value1, value2, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andSailPriceTsNotBetween(Long value1, Long value2) {
            addCriterion("SAIL_PRICE_TS not between", value1, value2, "sailPriceTs");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andHighestCommIsNull() {
            addCriterion("HIGHEST_COMM is null");
            return (Criteria) this;
        }

        public Criteria andHighestCommIsNotNull() {
            addCriterion("HIGHEST_COMM is not null");
            return (Criteria) this;
        }

        public Criteria andHighestCommEqualTo(Double value) {
            addCriterion("HIGHEST_COMM =", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommNotEqualTo(Double value) {
            addCriterion("HIGHEST_COMM <>", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommGreaterThan(Double value) {
            addCriterion("HIGHEST_COMM >", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommGreaterThanOrEqualTo(Double value) {
            addCriterion("HIGHEST_COMM >=", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommLessThan(Double value) {
            addCriterion("HIGHEST_COMM <", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommLessThanOrEqualTo(Double value) {
            addCriterion("HIGHEST_COMM <=", value, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommIn(List<Double> values) {
            addCriterion("HIGHEST_COMM in", values, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommNotIn(List<Double> values) {
            addCriterion("HIGHEST_COMM not in", values, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommBetween(Double value1, Double value2) {
            addCriterion("HIGHEST_COMM between", value1, value2, "highestComm");
            return (Criteria) this;
        }

        public Criteria andHighestCommNotBetween(Double value1, Double value2) {
            addCriterion("HIGHEST_COMM not between", value1, value2, "highestComm");
            return (Criteria) this;
        }

        public Criteria andCommPropIsNull() {
            addCriterion("COMM_PROP is null");
            return (Criteria) this;
        }

        public Criteria andCommPropIsNotNull() {
            addCriterion("COMM_PROP is not null");
            return (Criteria) this;
        }

        public Criteria andCommPropEqualTo(Double value) {
            addCriterion("COMM_PROP =", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropNotEqualTo(Double value) {
            addCriterion("COMM_PROP <>", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropGreaterThan(Double value) {
            addCriterion("COMM_PROP >", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropGreaterThanOrEqualTo(Double value) {
            addCriterion("COMM_PROP >=", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropLessThan(Double value) {
            addCriterion("COMM_PROP <", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropLessThanOrEqualTo(Double value) {
            addCriterion("COMM_PROP <=", value, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropIn(List<Double> values) {
            addCriterion("COMM_PROP in", values, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropNotIn(List<Double> values) {
            addCriterion("COMM_PROP not in", values, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropBetween(Double value1, Double value2) {
            addCriterion("COMM_PROP between", value1, value2, "commProp");
            return (Criteria) this;
        }

        public Criteria andCommPropNotBetween(Double value1, Double value2) {
            addCriterion("COMM_PROP not between", value1, value2, "commProp");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIsNull() {
            addCriterion("CREATER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIsNotNull() {
            addCriterion("CREATER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCreaterIdEqualTo(Long value) {
            addCriterion("CREATER_ID =", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotEqualTo(Long value) {
            addCriterion("CREATER_ID <>", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdGreaterThan(Long value) {
            addCriterion("CREATER_ID >", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdGreaterThanOrEqualTo(Long value) {
            addCriterion("CREATER_ID >=", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdLessThan(Long value) {
            addCriterion("CREATER_ID <", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdLessThanOrEqualTo(Long value) {
            addCriterion("CREATER_ID <=", value, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdIn(List<Long> values) {
            addCriterion("CREATER_ID in", values, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotIn(List<Long> values) {
            addCriterion("CREATER_ID not in", values, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdBetween(Long value1, Long value2) {
            addCriterion("CREATER_ID between", value1, value2, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreaterIdNotBetween(Long value1, Long value2) {
            addCriterion("CREATER_ID not between", value1, value2, "createrId");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterionForJDBCDate("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andModifierIdIsNull() {
            addCriterion("MODIFIER_ID is null");
            return (Criteria) this;
        }

        public Criteria andModifierIdIsNotNull() {
            addCriterion("MODIFIER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andModifierIdEqualTo(Long value) {
            addCriterion("MODIFIER_ID =", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdNotEqualTo(Long value) {
            addCriterion("MODIFIER_ID <>", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdGreaterThan(Long value) {
            addCriterion("MODIFIER_ID >", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdGreaterThanOrEqualTo(Long value) {
            addCriterion("MODIFIER_ID >=", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdLessThan(Long value) {
            addCriterion("MODIFIER_ID <", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdLessThanOrEqualTo(Long value) {
            addCriterion("MODIFIER_ID <=", value, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdIn(List<Long> values) {
            addCriterion("MODIFIER_ID in", values, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdNotIn(List<Long> values) {
            addCriterion("MODIFIER_ID not in", values, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdBetween(Long value1, Long value2) {
            addCriterion("MODIFIER_ID between", value1, value2, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifierIdNotBetween(Long value1, Long value2) {
            addCriterion("MODIFIER_ID not between", value1, value2, "modifierId");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion("MODIFY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion("MODIFY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeEqualTo(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME =", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME <>", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME >", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME >=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThan(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME <", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("MODIFY_TIME <=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIn(List<Date> values) {
            addCriterionForJDBCDate("MODIFY_TIME in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("MODIFY_TIME not in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("MODIFY_TIME between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("MODIFY_TIME not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}